from sqlalchemy import Column, DateTime, Integer, String
from database.db_init import Base


class Machine_data_processing(Base):
    __tablename__ = "Machine_Data_Processing"
    ID = Column(Integer, primary_key=True, index=True)
    MachineID = Column(Integer, unique=False)
    SensorID = Column(Integer, unique=False)
    AIModelID = Column(Integer, unique=False)
    RawDataJSON = Column(String, unique=False)
    AnalysisResultJSON = Column(String, unique=False)
    RawDataRetrievalTime = Column(DateTime, unique=False)
    ProcessingTime = Column(DateTime, unique=False)
    Remarks = Column(String, unique=False)
